The following error message is produced when reading from an SQL view that is created with an embedded LIBNAME statement that specifies the META engine:

For example, suppose you defined the following view from the table INVALID_MEMPTR_TEST that is accessed from the "Test Library" metadata library via the META engine:

The error occurs when reading the view, as in these two steps:

If you are submitting your program in batch mode, or to a Workspace Server or stored process server, the correct number of observations from the underlying table are read through the view. However, the SAS System option OBS is set to 0 and the program continues in syntax check mode. This mode of execution will occur when projects and jobs are run using SAS^® Enterprise Guide^®, SAS^® Data Integration Studio, and other clients.

If you are submitting your program in an interactive mode, such as Display Manager Mode or Interactive Line Mode, the correct number of observations are read through the view and the program continues to run normally.

As a circumvention, use the appropriate SAS^® or DBMS engine on the LIBNAME in the view definition. For example:

See SAS Note 19486 "'ERROR: Invalid memptr' occurs and the SAS® session becomes unresponsive when trying to access a view via a libref with the META LIBNAME engine" for a related problem.

Operating System and Release Information